
declare @KEHOACH Table(
	DON_VI_ID int,
	[CHI_TIEU_ID] int
)
	SELECT   DON_VI_ID, [CHI_TIEU_ID]
	FROM [NV].[KEHOACH]
	WHERE [NAM_KE_HOACH_ID] = 2016 and STATUS_ID=10 and 
	[CHI_TIEU_ID] in (select [CHI_TIEU_ID] from [NV].[DONVI_CHITIEU] 
	where [NAM_KE_HOACH_ID] = 2016 and [DON_VI_ID]  = 43 and FLAG = 1)
		order by DON_VI_ID


		declare @DONVI_CHITIEU Table(
	DON_VI_ID int,
	[CHI_TIEU_ID] int
)
